SnowPro Advanced Architect v1.0

Page:    1 / 8   
Exam contains 109 questions
Expand All

An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user’s role must have which privileges? (Choose two.)

  • A. IMPORT SHARE;
  • B. IMPORT PRIVILEGES;
  • C. CREATE DATABASE;
  • D. CREATE SHARE;
  • E. IMPORT DATABASE;


Answer : BC

Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.
How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

  • A. Use Snowpipe with auto-ingest.
  • B. Use a COPY command with a task.
  • C. Use a materialized view on an external table.
  • D. Use the COPY INTO command.
  • E. Use a combination of a task and a stream.


Answer : AE

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

  • A. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
  • B. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
  • C. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
  • D. All rows loaded using a specific COPY statement will have the same timestamp value.


Answer : C

How does a standard virtual warehouse policy work in Snowflake?

  • A. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
  • B. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.
  • C. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.
  • D. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.


Answer : A

Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

  • A. External table
  • B. Materialized view
  • C. Search optimization
  • D. Result cache


Answer : B

An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

  • A. Search optimization service
  • B. Materialized view
  • C. Time Travel
  • D. Zero-copy cloning
  • E. Secure views


Answer : D

A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps:
Confirmed Private Link URLs are working by logging in with a username/password account
Verified DNS resolution by running nslookups against Private Link URLs
Validated connectivity using SnowCD
Disabled public access using a network policy set to use the company’s IP address range
However, the following error message is received when using SSO to log into the company account:
IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

  • A. Alter the Azure security integration to use the Private Link URLs.
  • B. Add the IP address in the error message to the allowed list in the network policy.
  • C. Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
  • D. Update the configuration of the Azure AD SSO to use the Private Link URLs.
  • E. Open a case with Snowflake Support to authorize the Private Link URLs’ access to the account.


Answer : BC

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

  • A. Choose columns that are frequently used in join predicates.
  • B. Choose lower cardinality columns to support clustering keys and cost effectiveness.
  • C. Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
  • D. Choose cluster columns that are most actively used in selective filters.
  • E. Choose cluster columns that are actively used in the GROUP BY clauses.


Answer : AD

Which Snowflake data modeling approach is designed for BI queries?

  • A. 3 NF
  • B. Star schema
  • C. Data Vault
  • D. Snowflake schema


Answer : D

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

  • A. A task scheduled in a UTC-based schedule will have no issues with the time changes.
  • B. Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
  • C. A task will move to a suspended state during the daylight savings time change.
  • D. A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
  • E. A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.


Answer : BD

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

  • A. Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
  • B. Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
  • C. Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
  • D. This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.


Answer : D

A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

  • A. Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
  • B. Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
  • C. Increase the size of the virtual warehouse to size X-Large.
  • D. Reduce the amount of data that is being processed through this workload.
  • E. Set the connection timeout to a higher value than its default.


Answer : AC

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

  • A. SYSTEM$CLUSTERING_INFORMATION
  • B. SYSTEM$CLUSTERING_USAGE
  • C. SYSTEM$CLUSTERING_DEPTH
  • D. SYSTEM$CLUSTERING_KEYS
  • E. SYSTEM$CLUSTERING_PERCENT


Answer : AC

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.
What command will accomplish this?

  • A. CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
  • B. CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
  • C. CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
  • D. CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);


Answer : C

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

  • A. Clone a table from a share.
  • B. Grant modify permissions on the share.
  • C. Create a table from the shared database.
  • D. Create additional views inside the shared database.
  • E. Create a table stream on the shared table.


Answer : CE

Page:    1 / 8   
Exam contains 109 questions
Expand All

Talk to us!

Have any questions or issues ? Please dont hesitate to contact us

[email protected]

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy